Running The Scripts Using Pan

Procedure

1. Use Spoon to configure the step. Save the script, and make a note of the location.
2. Open a command prompt or save the following steps into a *.bat file. Using a *.bat file allows for repeated execution from a scheduler.
3. Navigate to the Kettle directory.

   cd C:\Kettle\data-integration\

4. Run Pan. The full path is required to run pan.bat if running from a *.bat file.

   C:\Kettle\data-integration\Pan.bat

5. Add the required parameters to the process.
   1. The file value specifies which Kettle job to run.

      -file:"Path\To\NameOfTransformScript.ktr"

   2. The level value specifies which level of Kettle logging to record.

      -level:"Detailed"

   3. The value of any named parameters set in the transform can optionally be passed using the -param switch.

      - param:access_token=xxxxxxxx

6. It is recommended to send the Kettle log to a file rather than let it go to the command line. Use > to send the output to the specified file. Use >> to append the output to the specified file.

   > C:\Testing\KitchenRun.log

• Using the Twitter plugin
  • Twitter Plugin Options - Keys
  • Twitter Plugin Options - Receive Mode
  • Twitter Plugin Options - Post Mode
  • Twitter Plugin Options - Direct Message Mode
  • Tweeting Limits When Using the Twitter Plugin
  • Data Available Twitter Plugin
  • Integrating Twitter in Campaign Manager
  • Loading Data Into Engine
  • Running the scripts using Pan